package srdb.migration.Util;

public interface Constants {

	String COLUMN_TABLE_NAME = "TABLE_NAME";

	String TEMPLATE_SQL_PARTITION_ORACLE = "SELECT * FROM USER_TAB_PARTITIONS WHERE TABLE_NAME=''{0}''";
	String TEMPLATE_SQL_PARTITION_SRDB = "SELECT relhassubclass,relhasrules FROM sr_class WHERE relname=''{0}''";
	String TEMPLATE_SQL_ROW_TOTAL = "SELECT COUNT(*) FROM {0}.{1}";

	String TEMPLATE_CON_URL_ORACLE = "jdbc:oracle:thin:@{0}:{1}:{2}";
	String TEMPLATE_CON_URL_MYSQL = "jdbc:mysql://{0}:{1}/{2}";
	String TEMPLATE_CON_URL_SQLSERVER = "jdbc:sqlserver://{0}:{1};databaseName={2}";
	String TEMPLATE_CON_URL_DB2 = "jdbc:db2://{0}:{1}/{2}:retrieveMessagesFromServerOnGetMessage=true;";
	String TEMPLATE_CON_URL_SRDB = "jdbc:srdbsql://{0}:{1}/{2}";

	String DRIVER_NAME_ORACLE = "oracle.jdbc.OracleDriver";
	String DRIVER_NAME_MYSQL = "com.mysql.jdbc.Driver";
	String DRIVER_NAME_SQLSERVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	String DRIVER_NAME_DB2 = "com.ibm.db2.jcc.DB2Driver";
	String DRIVER_NAME_SRDB = "org.srdbsql.Driver";

	int PARSE_DATA_ARRAY_LENGTH = 5;
	int INDEX_TABLE_COUNT_TOTAL = 0;
	int INDEX_ROW_COUNT_TOTAL = 1;
	int INDEX_TABLE_COUNT_TENMILLION_ABOVE = 2;
	int INDEX_TABLE_COUNT_BETWEEN_MILLION_TENMILLION = 3;
	int INDEX_TABLE_COUNT_MILLION_BELOW = 4;

	int NUM_MILLION = 1000000;
	int NUM_TEN_MILLION = 10000000;

	int MIG_UNKNOWN = 0;
	int MIG_ALL = 1;
	int MIG_PARSE_ONLY = 2;
	int MIG_CUSTOMIZE = 3;
	int MIG_SCHEMA_ONLY = 4;
	int MIG_DATA_ONLY = 5;

	int ORACLE_VERSION_UNKNOWN = 0;
	int ORACLE_VERSION_817 = 1;
	int ORACLE_VERSION_9I = 2;
	int ORACLE_VERSION_11G = 3;

}
